------------ SEQUENCES :

CREATE SEQUENCE TRANSFER_SEQ START WITH 1 INCREMENT BY 1;
CREATE SEQUENCE TRANSFER_DETAILS_SEQ START WITH 1 INCREMENT BY 1;

COMMIT;

------------ TRIGGERS :
 
-- T_AUDIT_TRANSFER_DETAILS
CREATE OR REPLACE TRIGGER T_AUDIT_TRANSFER_DETAILS
BEFORE INSERT ON EMODE_INC.AUDIT_TRANSFER_DETAILS
FOR EACH ROW
BEGIN
   SELECT TRANSFER_DETAILS_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
END T_AUDIT_TRANSFER_DETAILS ;
/
 